UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kVor6DPiNYWon2qmKZ46+LFAyzAnqbhHWXGhkT53oo4='
WHERE
key_id = '48f77adba6d5152bf7a9dbf496d662bfa189a532a60fbb2f59590ce49013bbd2'
AND (
token = 'kVor6DPiNYWon2qmKZ46+LFAyzAnqbhHWXGhkT53oo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)