UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zmjCnoZurYZDjYvnLnX2bGV79NC0ocDlXQ7NyfzqvJk='
WHERE
key_id = '3bddf5b7e880cdfa700991eebd0589a3f8645f2cc9fa42634c39f782e01c3fad'
AND (
token = 'zmjCnoZurYZDjYvnLnX2bGV79NC0ocDlXQ7NyfzqvJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)