UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5A80EDp5ACg25KkQnSR8kTvQ5TCKs7yCvdrCu9uc+Xw='
WHERE
key_id = 'c94759a20e3a4006f98e726e3bfffbc748b0147aea3bb155106e17c91705bf4b'
AND (
token = '5A80EDp5ACg25KkQnSR8kTvQ5TCKs7yCvdrCu9uc+Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)