UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '22ShiSwtQ2n0pKQwt2zZ+Hh44S58/MALAxk0JzqAlgM='
WHERE
key_id = '3b97e51bf1c413f029e047bf3068405022731c378c1ebd86fd50beaf00e8344d'
AND (
token = '22ShiSwtQ2n0pKQwt2zZ+Hh44S58/MALAxk0JzqAlgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)