UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GSSjGh4uHld9L0LJd4NTTC5DUt9IGZRCJ/F3idfCuoY=' 
WHERE 
  key_id = '9b2a57c7f3dfc6199cf91cf13e8183fa2bd960d964a964db2899a68ef97aee8d' 
  AND (
    token = 'GSSjGh4uHld9L0LJd4NTTC5DUt9IGZRCJ/F3idfCuoY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042