UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FQ7iqMlb9hTQOLK2NdYQIiyuyVTW2oOeMGr+bjpDtE='
WHERE
key_id = '27ce5fa5fe4bf72bd62074160522fa590adc61bd421f067298da98b4c759c36b'
AND (
token = '6FQ7iqMlb9hTQOLK2NdYQIiyuyVTW2oOeMGr+bjpDtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)