UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gTSK90hcGn5oR/YxWwJYr77iGWuZqBYxDu/s7wygxrs='
WHERE
key_id = 'b7d0cabff3dd784d6d78a4b740c99f53d9dfe4236833efa5564757990979c331'
AND (
token = 'gTSK90hcGn5oR/YxWwJYr77iGWuZqBYxDu/s7wygxrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)