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