UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z5IHkOlttpmkN2jyS4S2EdNvCVoGmDIHdHiVVYdrthE='
WHERE
key_id = '299a80a3477e11d8f03223f43ee7e193516b1eb1338e305aaa81f8ce00854739'
AND (
token = 'Z5IHkOlttpmkN2jyS4S2EdNvCVoGmDIHdHiVVYdrthE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)