UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QABfG3t6Fb40Z6RY3kKGUYdGThEYv6Fz2Z18iy6UVJg=' 
WHERE 
  key_id = 'cfe1c1dd7c253df9e8e4ae0601cc722fd17c233e4e335adbfaee2c430c1bc6b6' 
  AND (
    token = 'QABfG3t6Fb40Z6RY3kKGUYdGThEYv6Fz2Z18iy6UVJg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034