UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sRVK1U4nQ5OrxOvln6zVsMLK4zHX0dq6jps3L5yRGyA=' 
WHERE 
  key_id = '99321855998446ebf889476f3e2d31d5f8035405021363564903a47e78697abe' 
  AND (
    token = 'sRVK1U4nQ5OrxOvln6zVsMLK4zHX0dq6jps3L5yRGyA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033