UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BF+qiQwlFfzoJvTN8jeJud18ka/BWGrfBfeqi5g0dEY=' 
WHERE 
  key_id = 'e5c312d514f40a0f030f2be99a6654ed11c5b4b2a77933f0c02b4405230d6711' 
  AND (
    token = 'BF+qiQwlFfzoJvTN8jeJud18ka/BWGrfBfeqi5g0dEY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040