UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pd8dHxrwI2xn7YSqVR2xCuDDzErqcHK6UG/NhUz0I8s=' 
WHERE 
  key_id = 'f82574bc9cf3b65db886fb174e41fbc097d5025d5e26122dc7a90ec31ce547f7' 
  AND (
    token = 'pd8dHxrwI2xn7YSqVR2xCuDDzErqcHK6UG/NhUz0I8s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041