UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jpjfxxZHEOcXdgHbandWG7PlWQxWXTWws0/LbHuvGCs=' 
WHERE 
  key_id = '08646935749cdde60d60d714669a6e0580cb1c46d92d4ef6fed0392891c072fc' 
  AND (
    token = 'jpjfxxZHEOcXdgHbandWG7PlWQxWXTWws0/LbHuvGCs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046