UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pYP07A88COl/jKEM+rF3xtl0ggG9oojQCk7F4/kk7Q='
WHERE
key_id = '0096d85c06b7e3ed724244234e577c93c2836b25e2cdcb3c70353b20bf091845'
AND (
token = '6pYP07A88COl/jKEM+rF3xtl0ggG9oojQCk7F4/kk7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)