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