UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5Bjd7BkvGzWJWjDKSiY9GEcYKBZQ7tXvS4esykwRNM='
WHERE
key_id = 'f5285ac445fc2c4e77365dedda7e886cef169dc435805a7e0625bd07778c7895'
AND (
token = 'D5Bjd7BkvGzWJWjDKSiY9GEcYKBZQ7tXvS4esykwRNM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)