UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pAAxuCxOjIYPqlRg37yNiuF33XZfcKQwMcqyU7y2VGw='
WHERE
key_id = 'a1e008388f95919a52fcece0de73a49d572f0d5450325817ac022a29770d937e'
AND (
token = 'pAAxuCxOjIYPqlRg37yNiuF33XZfcKQwMcqyU7y2VGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)