UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4tj5oX6YaM6pZfWGQXIhZ+4W+R2VDGWlcn3npg8zBU='
WHERE
key_id = '45a195ef94de684d29dc4f912ae447ebb0e1bd0c1145a56f740025914e37c8d3'
AND (
token = 'G4tj5oX6YaM6pZfWGQXIhZ+4W+R2VDGWlcn3npg8zBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)