UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4Nr5G1QPohqDS/psKozmPi0E+oMF/uy0Lxw8UHup9U='
WHERE
key_id = 'b16bf7fda2e479412f0d6f1922158168485ce5d9dc54a95fa45b18d3839fd2ac'
AND (
token = 'Z4Nr5G1QPohqDS/psKozmPi0E+oMF/uy0Lxw8UHup9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)