UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vDvrHre7w0Nvy+90g3eJjIK3vJUeqMKnW7Z7jsozTyM='
WHERE
key_id = 'be8fda60c4b397204e0c1e1688ef8b1e8e35c4ccbceacd66f71c6e1a67289512'
AND (
token = 'vDvrHre7w0Nvy+90g3eJjIK3vJUeqMKnW7Z7jsozTyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)