UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mklxb8eGoS0W1jDbGf4voHysuGDgaLcSS/MxI6qv2KU='
WHERE
key_id = '42429a51f2f43c01e1c17ea7445d3a3707599d44ea7852315496d5dacf116d82'
AND (
token = 'mklxb8eGoS0W1jDbGf4voHysuGDgaLcSS/MxI6qv2KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)