UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vAQhrASio/BnGsqUjqHNcj10Azx4eFan7vbzPy9XtgA='
WHERE
key_id = '533849e7ee938df0fc4bbe9dc308fb10b5cdb252179849c652b71f474f8a1123'
AND (
token = 'vAQhrASio/BnGsqUjqHNcj10Azx4eFan7vbzPy9XtgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)