UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RdALPCh7xX31ufHbSk1chcnhC2LPL3W6vc8DwZgf260='
WHERE
key_id = 'f5d178f335374748dc12a448b7ff7459763000eaa5a0e0bb8eb34109301a7782'
AND (
token = 'RdALPCh7xX31ufHbSk1chcnhC2LPL3W6vc8DwZgf260='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)