UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '294AaCDXBz/RPpV+tIiTSFVgwDy1Ei0k+CT5VmU8Jco='
WHERE
key_id = '538808d50129c6f76e3160e44191e89026a780d01e807ea2fb46681c7d9b8bbe'
AND (
token = '294AaCDXBz/RPpV+tIiTSFVgwDy1Ei0k+CT5VmU8Jco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)