UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YMgTTQcwlCijDWrKTU5gY1NX3fO3uBIjOCZqxdxNTpE='
WHERE
key_id = '27b4a6305444f714e4de92aa3f4fce8a5c791e3a81dba29cd13bb18d72e15662'
AND (
token = 'YMgTTQcwlCijDWrKTU5gY1NX3fO3uBIjOCZqxdxNTpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)