UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzYj2OLHXmZ/qF0fuo31cGxiV59bmERumFnCD2p2J+Q='
WHERE
key_id = 'c496de9f9def6741dffc53e7c225b0162d2b80d01c82e403a9f191c1b36a09a7'
AND (
token = 'mzYj2OLHXmZ/qF0fuo31cGxiV59bmERumFnCD2p2J+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)