UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXF93YaxyVnk03XvREG4NCTIfJOHOfKXpTyAhLcIM2U='
WHERE
key_id = '9e8e58e68c1c1f09d318abe81d1f2efb40cbfd801184ab3443c7e516948609be'
AND (
token = 'lXF93YaxyVnk03XvREG4NCTIfJOHOfKXpTyAhLcIM2U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)