UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oJj2oDWIbuIQvxY3bAZk6HD/Iw7eO4CNGL9txnLfvGU=' 
WHERE 
  key_id = 'c24aae4484b8501f79617e87316f8ad911187dacb405a5dd95b05773a11a9607' 
  AND (
    token = 'oJj2oDWIbuIQvxY3bAZk6HD/Iw7eO4CNGL9txnLfvGU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022