UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '49zRw99dmyMDF47HTPUHri/nrZ5621z2LpEsUB7MiRk=' 
WHERE 
  key_id = 'da8f7822f5889fcf5cedd798b8b2925d8bd14ec577e4908c78186264725b5c69' 
  AND (
    token = '49zRw99dmyMDF47HTPUHri/nrZ5621z2LpEsUB7MiRk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044