UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LJ834vEnUU+D9hEN6Ds7Jfe0KD7rnjaGZSeER4qkThc='
WHERE
key_id = '3bad303f155585e3f7cc531c640007b92601e47b6edbe77070a81dda4c256023'
AND (
token = 'LJ834vEnUU+D9hEN6Ds7Jfe0KD7rnjaGZSeER4qkThc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)