UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1lxkhH6gqAZgNONqz9TOQMWrX9Ag6rLi+hIllD5KxA='
WHERE
key_id = '7f5943b38ecdeb4a88648ca2a2cf9199315e9dd4286007bf6dada20690b25aca'
AND (
token = 'X1lxkhH6gqAZgNONqz9TOQMWrX9Ag6rLi+hIllD5KxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)