UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Gbu8xlnD6944U8YVzxHl5IjjVdwDj6j7Zq4fC+27mY='
WHERE
key_id = '9766396330196bc21dbf63d46124d838ae32fae2d4250b720db99a867225f023'
AND (
token = '6Gbu8xlnD6944U8YVzxHl5IjjVdwDj6j7Zq4fC+27mY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)