UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KRyY6xROmNzegt5bBjAQt+FlJEPV3VaDrBMA0Y64WE='
WHERE
key_id = '3a1d246fef323177bd85fba414f24e89555c4ffb74e9a163cd00ca987406eced'
AND (
token = '7KRyY6xROmNzegt5bBjAQt+FlJEPV3VaDrBMA0Y64WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)