UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+yWp+nTRpPRQ1ZyU2gaBH6M9/Qk9XNDLfv2m8mOQmjA=' 
WHERE 
  key_id = '7781efd4beb1a54c750b67f3b1876daf79922f7a47f222f1e610da55282f48dd' 
  AND (
    token = '+yWp+nTRpPRQ1ZyU2gaBH6M9/Qk9XNDLfv2m8mOQmjA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021