UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VLfi0pL1cZiMLuHqHclrC1LdA1QfjU8QvX7fLe2Hbgk=' 
WHERE 
  key_id = '14b6287e2a7ff68697abc308354d840dcff23a0237f35f94a82adc3dcc6d6c7f' 
  AND (
    token = 'VLfi0pL1cZiMLuHqHclrC1LdA1QfjU8QvX7fLe2Hbgk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044