UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l6Tj4CdaW0yg00skjoLCXIIZi3KGRfgTq8hrc716dRU='
WHERE
key_id = 'b64b76af1ccf1566e9c9b33794d35a1d9cfe9fb561997ecf4ceb3841e89d71ca'
AND (
token = 'l6Tj4CdaW0yg00skjoLCXIIZi3KGRfgTq8hrc716dRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)