UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hm/5//KhYA3YE4aJOV7vi+lbXI2sDcPMDE+4SXe3Ndc=' 
WHERE 
  key_id = '4b1b465971dee651ac3f0a246daac32f9fb445eb5f2f294b11bed2171c9486ad' 
  AND (
    token = 'hm/5//KhYA3YE4aJOV7vi+lbXI2sDcPMDE+4SXe3Ndc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030