UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6IQr77bnSJMDihOzsQiGFGoSmMBUMdNwY7DIGYUNUw4='
WHERE
key_id = '0e787bf6e44f3b84996acd03ce5d8c2ae8708bd0b0ef13845f95a0b53f30f713'
AND (
token = '6IQr77bnSJMDihOzsQiGFGoSmMBUMdNwY7DIGYUNUw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)