UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xi5bLicbsC6HqFjuwtbksPxSly5fGEkaDGPJFc3z7CQ='
WHERE
key_id = '4b46808123e3b0a76dcccced91c5b1bdafe4399a764bf1c7e16ccf5bf3b710a9'
AND (
token = 'xi5bLicbsC6HqFjuwtbksPxSly5fGEkaDGPJFc3z7CQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)