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