UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4F8JkcPeUxasq1s6jxm2ey60faryXaxfT0ejK4cSGkk=' 
WHERE 
  key_id = '8c86ad1655f54797b3d5a5a6b0a65978ee8a20f0c8d2a2842b3b3f3b1722b3c2' 
  AND (
    token = '4F8JkcPeUxasq1s6jxm2ey60faryXaxfT0ejK4cSGkk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029