UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tESC6kWZcG6hQnhxfBAeh9ZKUzJY4IDaitmXPJnWIfU='
WHERE
key_id = '9959daec41104a0887d7a9c8bca04c7b8dc2929d8a8d1f9c90163edca1729ed7'
AND (
token = 'tESC6kWZcG6hQnhxfBAeh9ZKUzJY4IDaitmXPJnWIfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)