UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXiSiY0nk8Pp/fXXq79qMmMElcJ9zCHZas5SmHlr09U='
WHERE
key_id = '9fd1720d63539098d77a1b17567bfc48baaf13f7f845a89276fd5819fe6c7418'
AND (
token = 'jXiSiY0nk8Pp/fXXq79qMmMElcJ9zCHZas5SmHlr09U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)