UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iWvrNBYwN+9Al0FHQ0AQ5qQH/KzS9gKtRlS8icCoNzA=' 
WHERE 
  key_id = '26a46293300c81705b757feb4d2fd73f910ff018285d585ff1bb93a15fe3f873' 
  AND (
    token = 'iWvrNBYwN+9Al0FHQ0AQ5qQH/KzS9gKtRlS8icCoNzA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041