UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eYGZVp8xLtKa9p1wymKUuY1QTRwzcb4rjNkm9D/A7Jw=' 
WHERE 
  key_id = '277a4f6cb932aa5c36e2a2e08883588ebb1ca1df5c703cfcee304a12ad5283ac' 
  AND (
    token = 'eYGZVp8xLtKa9p1wymKUuY1QTRwzcb4rjNkm9D/A7Jw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049